<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
    <title>LuaSQL: Database connectivity for the Lua programming language</title>
    <link rel="stylesheet" href="http://www.keplerproject.org/doc.css" type="text/css"/>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
</head>
<body>

<div id="container">
	
<div id="product">
	<div id="product_logo"><a href="http://www.keplerproject.org">
		<img alt="LuaSQL logo" src="luasql.png"/>
	</a></div>
	<div id="product_name"><big><strong>LuaSQL</strong></big></div>
	<div id="product_description">Database connectivity for the Lua programming language</div>
</div> <!-- id="product" -->

<div id="main">
	
<div id="navigation">
<h1>LuaSQL</h1>
	<ul>
		<li><strong>Home</strong>
			<ul>
				<li><a href="index.html#overview">Overview</a></li>
				<li><a href="index.html#status">Status</a></li>
				<li><a href="index.html#download">Download</a></li>
				<li><a href="index.html#credits">Credits</a></li>
				<li><a href="index.html#contact">Contact us</a></li>
			</ul>
		</li>
		<li><a href="manual.html">Manual</a>
			<ul>
				<li><a href="manual.html#introduction">Introduction</a></li>
				<li><a href="manual.html#installation">Installation</a></li>
				<li><a href="manual.html#errors">Error handling</a></li>
				<li><a href="manual.html#environment_object">Environment</a></li>
				<li><a href="manual.html#connection_object">Connection</a></li>
				<li><a href="manual.html#cursor_object">Cursor</a></li>
				<li><a href="manual.html#postgres_extensions">PostgreSQL</a></li>
				<li><a href="manual.html#mysql_extensions">MySQL</a></li>
				<li><a href="manual.html#oracle_extensions">Oracle</a></li>
			</ul>
		</li>
		<li><a href="examples.html">Examples</a></li>
		<li><a href="history.html">History</a></li>
		<li><a href="license.html">License</a></li>
	</ul>
</div> <!-- id="navigation" -->

<div id="content">
<h2><a name="overview"></a>Overview</h2>
<p>
LuaSQL is a simple interface from Lua to a DBMS. It enables a Lua program to:
</p>
<ul>
	<li> Connect to ODBC, ADO, Oracle, MySQL, SQLite, JDBC, and PostgreSQL databases;</li>
	<li> Execute arbitrary SQL statements;</li>
	<li> Retrieve results in a row-by-row cursor fashion.</li>
</ul>

<p>
LuaSQL is free software and uses the same <a href="license.html">license</a>
as Lua 5.0.
</p>

<h2><a name="status"></a>Status</h2>
<p>LuaSQL version 2.0.1 (for Lua 5.0) is now available for
<a href="#download">download</a>.
</p>
<p>The PostgreSQL driver has been tested on Linux and MacOS X and is compatible
with PostgreSQL 7.x.</p>
<p>The ODBC driver has been tested on Windows (SQLServer and Microsoft Access
drivers).</p>
<p>The MySQL driver has been tested on Linux and is compatible with versions 4.0
and 4.1.</p>
<p>The Oracle driver has been tested on Windows and is compatible with OCI 8 API.</p>
<p>The SQLite driver had been tested on Linux and are compatible with versions 2.x.</p>
<p>The JDBC driver has been tested with LuaJava Beta 3 and JDK 1.4 (MySQL driver).</p>
<p>The ADO driver has been tested on Windows, with LuaCOM 1.3 (Microsoft Access driver).</p>

<h2><a name="download"></a>Download</h2>
<p>
LuaSQL can be downloaded in source code from the <a href=
"http://luaforge.net/project/showfiles.php?group_id=12">Lua
Forge</a> page.  If you are using
<a href="http://luaforge.net/projects/luabinaries/">LuaBinaries</a> Release 2
a Windows pre-compiled version of LuaSQL can also be found at the same
LuaForge page. 
</p>

<h2><a name="credits"></a>Credits</h2>

<h4>LuaSQL 2.0</h4>
<p>
Version 2.0 was redesigned by Roberto Ierusalimschy, Andr&eacute; Carregal
and Tom&aacute;s Guisasola as part of the
<a href="http://www.keplerproject.org">Kepler Project</a>.
The implementation is compatible with Lua 5.0 and was coded by
Tom&aacute;s Guisasola, Eduardo Quint&atilde;o, Thiago Ponte, Fabio Mascarenhas and
Danilo Tuler, with many invaluable contributions by Michael Roth, Tiago Dionizio
and Leonardo Godinho.</p>

<h4>LuaSQL 1.0</h4>
<p>
LuaSQL was designed by Pedro Miller Rabinovitch and Roberto
Ierusalimschy.
The first implementation was compatible with Lua 4.0a.
Many modifications were made but not distributed by Diego Nehab (ODBC),
Carlos Cassino, Tom&aacute;s Guisasola and Eduardo Quint&atilde;o (PostgreSQL).
</p>
<p>
LuaSQL development was sponsored by 
<a href="http://www.fabricadigital.com.br">F&aacute;brica Digital</a>.
</p>

<h2><a name="contact"></a>Contact us</h2>

<p>
For more information please
<a href="mailto:info-NO-SPAM-THANKS@keplerproject.org">contact us</a>.
Comments are welcome!
</p>

</div> <!-- id="content" -->

</div> <!-- id="main" -->

<div id="about">
	<p><a href="http://validator.w3.org/check?uri=referer"><img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" /></a></p>
	<p><small>
	$Id: index.html,v 1.14 2005/06/01 22:03:54 carregal Exp $
	</small></p>
</div> <!-- id="about" -->

</div> <!-- id="container" -->

</body>
</html> 
